CREATE TABLE t1 (
  c1 INTEGER,
  t1 TEXT,
  t2 VARCHAR(255),
  t3 CHAR(10)
);

ALTER TABLE t1
  ADD CONSTRAINT chk_c1 CHECK (c1 > 0),
  ADD CONSTRAINT chk_t1 CHECK (LENGTH(t1) > 0),
  ADD CONSTRAINT chk_t2 CHECK (CHAR_LENGTH(t2) > 0),
  ADD CONSTRAINT chk_t3 CHECK (CHARACTER_LENGTH(t3) > 0);
